StudentEnrollmentTermSummary

EntityType | Independent
Logical Entity Name | StudentEnrollmentTermSummary
Default Table Name | AdEnrollTerm
Logical Only | NO
Owner | dbo
Definition |
Note |

StudentEnrollmentTermSummary Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
TermId |  | INTEGER | YES |
Sequence |  | NUMERIC(4, 0) | NO |
BilledDate |  | DATETIME | YES |
TermGpa |  | NUMERIC(11, 6) | YES |
TermNumericAverage |  | NUMERIC(11, 6) | YES |
TermCreditHoursAttempted |  | NUMERIC(9, 2) | YES |
TermCreditHoursEarned |  | NUMERIC(9, 2) | YES |
TermClockHoursAttempted |  | NUMERIC(9, 2) | YES |
TermClockHoursEarned |  | NUMERIC(9, 2) | YES |
TermGpaPoints |  | NUMERIC(9, 2) | YES |
TermMinutesAttended |  | NUMERIC(11, 2) | YES |
TermMinutesAbsent |  | NUMERIC(9, 2) | YES |
CumulativeGpa |  | NUMERIC(11, 6) | YES |
CumulativeNumericAverage |  | NUMERIC(11, 6) | YES |
CumulativeCreditHoursAttempted |  | NUMERIC(9, 2) | YES |
CumulativeCreditHoursEarned |  | NUMERIC(9, 2) | YES |
CumulativeClockHoursAttempted |  | NUMERIC(9, 2) | YES |
CumulativeClockHoursEarned |  | NUMERIC(9, 2) | YES |
CumulativeGpaPoints |  | NUMERIC(9, 2) | YES |
CumulativeMinutesAttended |  | NUMERIC(11, 2) | YES |
CumulativeMinutesAbsent |  | NUMERIC(9, 2) | YES |
TermCreditHoursScheduled |  | NUMERIC(9, 2) | YES |
TermClockHoursScheduled |  | NUMERIC(9, 2) | YES |
Note |  | VARCHAR(255) | YES |
SAPStatus |  | CHAR(1) | YES |
EnrollmentStatusId |  | INTEGER | YES |
HonorsDescription |  | VARCHAR(50) | YES |
CreatedDateTime |  | DATETIME | NO |
LastModifiedDateTime |  | DATETIME | NO |
LastModifiedUserId |  | INTEGER | NO |
RowVersion |  | TIMESTAMP/DATE | NO |
HonorId |  | INTEGER | YES |
SapStatusId |  | INTEGER | YES |
StudentTermGpa |  | NUMERIC(11, 6) | YES |
StudentTermCreditHoursAttempted |  | NUMERIC(11, 2) | YES |
StudentTermClockHoursAttempted |  | NUMERIC(11, 2) | YES |
StudentTermGpaPoints |  | NUMERIC(11, 2) | YES |
StudentCumulativeGpa |  | NUMERIC(11, 6) | YES |
StudentCumulativeCreditHoursAttempted |  | NUMERIC(11, 2) | YES |
StudentCumulativeClockHoursAttempted |  | NUMERIC(11, 2) | YES |
StudentCumulativeGpaPoints |  | NUMERIC(11, 2) | YES |
StudentEnrollmentTermSummaryId |  | INTEGER | NO |
CumulativeGpaCredits |  | NUMERIC(9, 2) | YES |
TermMinutesMakeupAttended |  | INTEGER | YES |
CumulativeMinutesMakeupAttended |  | INTEGER | YES |
BgRndSetIdentifier |  | INTEGER | NO |
GradeLevelEvaluation |  | BIT | NO |
GradeLevelEvauationlDate |  | DATETIME | YES |
TermRegsteredCreditHours |  | NUMERIC(9, 2) | YES |
TermRegisteredClockHours |  | NUMERIC(9, 2) | YES |
StudentTermCreditHoursEarned |  | NUMERIC(9, 2) | YES |
StudentTermClockHoursEarned |  | NUMERIC(9, 2) | YES |
StudentCumulativeCreditHoursEarned |  | NUMERIC(9, 2) | YES |
StudentCumulativeClockHoursEarned |  | NUMERIC(9, 2) | YES |
TermAuditCreditHoursScheduled |  | NUMERIC(9, 2) | YES |
TermAssociatedGpaNumerator |  | MONEY(19, 4) | YES |
TermAssociatedGpaDenominator |  | MONEY(19, 4) | YES |
SAPCheckpoint |  | TINYINT | NO |
PartialSAPTerm |  | BIT | NO |
SapProcessType |  | CHAR(1) | NO |
StudentTermCreditHoursScheduled |  | NUMERIC(9, 2) | YES |
StudentTermAuditCreditHoursScheduled |  | NUMERIC(9, 2) | YES |
StudentTermClockHoursScheduled |  | NUMERIC(9, 2) | YES |
StudentTermRegisteredCreditHours |  | NUMERIC(9, 2) | YES |
StudentTermRegisteredClockHours |  | NUMERIC(9, 2) | YES |
StudentTermEnrollmentStatusId |  | INTEGER | YES |
TermGroupId |  | INTEGER | YES |
StudentId |  | INTEGER | YES |
StudentEnrollmentPeriodId |  | INTEGER | YES |

StudentEnrollmentTermSummary Keys

Key Name | Key Type | Keys
AdEnrollTerm_AdEnrollTermID_U_C_IDX | PrimaryKey | StudentEnrollmentTermSummaryId
AdEnrollTerm_SyStudentID_N_N_IDX | Inversion Entry | Id_1
AdEnrollTerm_AdTermID_AdAttStatId_AdEnrollId_AdEnrollTermID_U_N_IDX | Alternate Key | EnrollmentStatusId, Id_1
AdEnrollTerm_AdEnrollID_Sequence_U_N_IDX | Unique Constraint | Id_1, Sequence
AdEnrollTerm_AdEnrollTermID_GradeLevelEval_N_N_IDX | Inversion Entry | Id_1, GradeLevelEvaluation
AdEnrollTerm_AdEnrollId_AdTermId_TermAuditCreditsSched_U_N_IDX | Alternate Key | Id_1, TermAuditCreditHoursScheduled

StudentEnrollmentTermSummary Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
StudentEnrollmentPeriod | Non-Identifying | One To Zero or More |  |  |  | Id_1 | NO
Student | Non-Identifying | Zero or One to Zero or More |  |  |  | Id_1 | NO
Honor | Non-Identifying | Zero or One to Zero or More |  |  |  | HonorId | NO
Student | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentId | NO
StudentEnrollmentPeriod | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentEnrollmentPeriodId | NO
EnrollmentStatus | Non-Identifying | Zero or One to Zero or More |  |  |  | EnrollmentStatusId | NO
Term | Non-Identifying | Zero or One to Zero or More |  |  |  | TermId | NO
EnrollmentStatus | Non-Identifying | Zero or One to Zero or More |  |  |  | EnrollmentStatusId | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype
StudentEnrollmentTermRelationship | Identifying | One To Zero or More |  |  |  |  | NO

StudentEnrollmentTermSummary Check Constraints

Check Constraint Name | CheckConstraint

StudentEnrollmentTermSummary Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.StudentEnrollmentTermSummary | NO |  |  |
Physical (Microsoft SQL Server) dbo.AdEnrollTerm | NO |  |  |

StudentEnrollmentTermSummary Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | CourseRegistration
Logical | Grades/Attendance
Logical | StudentEnrollment
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Academic Records

StudentEnrollmentTermSummary Data Movement Rules

Name | Type | Rule Text/Value